Evaluation of parameter uncertainties in nonlinear regression using Microsoft Excel Spreadsheet
نویسندگان
چکیده
منابع مشابه
Evaluation of parameter uncertainties in nonlinear regression using Microsoft Excel Spreadsheet
Background: Nonlinear relationships are common in the environmental discipline. Spreadsheet packages such as Microsoft Excel come with an add-on for nonlinear regression, but parameter uncertainty estimates are not yet available. The purpose of this paper is to use Monte Carlo and bootstrap methods to estimate nonlinear parameter uncertainties with a Microsoft Excel spreadsheet. As an example, ...
متن کاملLICSS - a chemical spreadsheet in microsoft excel
BACKGROUND Representations of chemical datasets in spreadsheet format are important for ready data assimilation and manipulation. In addition to the normal spreadsheet facilities, chemical spreadsheets need to have visualisable chemical structures and data searchable by chemical as well as textual queries. Many such chemical spreadsheet tools are available, some operating in the familiar Micros...
متن کاملNonlinear Parameter Estimation Using Spreadsheet Software
Many fundamental processes in the natural and physical sciences exhibit substantial nonlinear relations among the component variables. Instructing students on how to identify parameters in models for such relations based on measured data, and providing a means to illustrate the impacts of specific components on the behavior of nonlinear relationships, is therefore a critical element of universi...
متن کاملA step-by-step guide to non-linear regression analysis of experimental data using a Microsoft Excel spreadsheet
The objective of this present study was to introduce a simple, easily understood method for carrying out non-linear regression analysis based on user input functions. While it is relatively straightforward to fit data with simple functions such as linear or logarithmic functions, fitting data with more complicated non-linear functions is more difficult. Commercial specialist programmes are avai...
متن کاملSimulation of axonal excitability using a Spreadsheet template created in Microsoft Excel
The objective of this present study was to implement an established simulation protocol (A.M. Brown, A methodology for simulating biological systems using Microsoft Excel, Comp. Methods Prog. Biomed. 58 (1999) 181-90) to model axonal excitability. The simulation protocol involves the use of in-cell formulas directly typed into a spreadsheet and does not require any programming skills or use of ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Environmental Systems Research
سال: 2015
ISSN: 2193-2697
DOI: 10.1186/s40068-015-0031-4